IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[subscription_applicant]') AND TYPE in (N'U'))
BEGIN
CREATE Table subscription_applicant
(
    subscription_applicant_id INT IDENTITY(1,1) NOT NULL,
    email NVARCHAR(200) NULL,
    name nvarchar(200) NULL,
    telephone nvarchar(100) null,
    apply_date DateTime DEFAULT(GETDATE()) NOT NULL,
    create_date DATETIME DEFAULT(GETDATE()) NOT NULL,
    update_date DATETIME 
	CONSTRAINT PK_subscription_applicant_id PRIMARY KEY CLUSTERED (subscription_applicant_id)
) 
END
GO